import pandas as pd
from pyecharts import options as opts
from pyecharts.charts import Line
from pyecharts.globals import ThemeType
df=pd.read_excel('全国人口年度数据.xlsx',index_col=0)
df=df.sort_index(axis='columns')
line=Line(init_opts=opts.InitOpts(
    width='2000px',height='600px',
    theme=ThemeType.SHINE,page_title='折线图'))
line.add_xaxis(xaxis_data=df.columns.tolist())
line.add_yaxis(series_name='年末总人数',y_axis=df.loc['年末总人口（万人）'])
line.add_yaxis(series_name='城镇人口',y_axis=df.loc['城镇人口（万人）'])
line.add_yaxis(series_name='乡村人口',y_axis=df.loc['乡村人口（万人）'])
line.set_global_opts(
    title_opts=opts.TitleOpts(
        title='2003-2022年全国年末总人口，城镇人口和乡村人口折线图',
        pos_left='center'),
    yaxis_opts=opts.AxisOpts(name='人口（万人）',
                             name_location='center',name_gap=55,min_=45000),
    legend_opts=opts.LegendOpts(pos_right='10%',pos_top='5%')
)
line.render('例7-1.html')